package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class VendorinfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public VendorinfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andVendorcodeIsNull() {
            addCriterion("VendorCode is null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIsNotNull() {
            addCriterion("VendorCode is not null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeEqualTo(String value) {
            addCriterion("VendorCode =", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotEqualTo(String value) {
            addCriterion("VendorCode <>", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThan(String value) {
            addCriterion("VendorCode >", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThanOrEqualTo(String value) {
            addCriterion("VendorCode >=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThan(String value) {
            addCriterion("VendorCode <", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThanOrEqualTo(String value) {
            addCriterion("VendorCode <=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLike(String value) {
            addCriterion("VendorCode like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotLike(String value) {
            addCriterion("VendorCode not like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIn(List<String> values) {
            addCriterion("VendorCode in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotIn(List<String> values) {
            addCriterion("VendorCode not in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeBetween(String value1, String value2) {
            addCriterion("VendorCode between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotBetween(String value1, String value2) {
            addCriterion("VendorCode not between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andBornnoIsNull() {
            addCriterion("BornNo is null");
            return (Criteria) this;
        }

        public Criteria andBornnoIsNotNull() {
            addCriterion("BornNo is not null");
            return (Criteria) this;
        }

        public Criteria andBornnoEqualTo(String value) {
            addCriterion("BornNo =", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotEqualTo(String value) {
            addCriterion("BornNo <>", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoGreaterThan(String value) {
            addCriterion("BornNo >", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoGreaterThanOrEqualTo(String value) {
            addCriterion("BornNo >=", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoLessThan(String value) {
            addCriterion("BornNo <", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoLessThanOrEqualTo(String value) {
            addCriterion("BornNo <=", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoLike(String value) {
            addCriterion("BornNo like", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotLike(String value) {
            addCriterion("BornNo not like", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoIn(List<String> values) {
            addCriterion("BornNo in", values, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotIn(List<String> values) {
            addCriterion("BornNo not in", values, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoBetween(String value1, String value2) {
            addCriterion("BornNo between", value1, value2, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotBetween(String value1, String value2) {
            addCriterion("BornNo not between", value1, value2, "bornno");
            return (Criteria) this;
        }

        public Criteria andVendornameIsNull() {
            addCriterion("VendorName is null");
            return (Criteria) this;
        }

        public Criteria andVendornameIsNotNull() {
            addCriterion("VendorName is not null");
            return (Criteria) this;
        }

        public Criteria andVendornameEqualTo(String value) {
            addCriterion("VendorName =", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameNotEqualTo(String value) {
            addCriterion("VendorName <>", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameGreaterThan(String value) {
            addCriterion("VendorName >", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameGreaterThanOrEqualTo(String value) {
            addCriterion("VendorName >=", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameLessThan(String value) {
            addCriterion("VendorName <", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameLessThanOrEqualTo(String value) {
            addCriterion("VendorName <=", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameLike(String value) {
            addCriterion("VendorName like", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameNotLike(String value) {
            addCriterion("VendorName not like", value, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameIn(List<String> values) {
            addCriterion("VendorName in", values, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameNotIn(List<String> values) {
            addCriterion("VendorName not in", values, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameBetween(String value1, String value2) {
            addCriterion("VendorName between", value1, value2, "vendorname");
            return (Criteria) this;
        }

        public Criteria andVendornameNotBetween(String value1, String value2) {
            addCriterion("VendorName not between", value1, value2, "vendorname");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNull() {
            addCriterion("AreaNo is null");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNotNull() {
            addCriterion("AreaNo is not null");
            return (Criteria) this;
        }

        public Criteria andAreanoEqualTo(String value) {
            addCriterion("AreaNo =", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotEqualTo(String value) {
            addCriterion("AreaNo <>", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThan(String value) {
            addCriterion("AreaNo >", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThanOrEqualTo(String value) {
            addCriterion("AreaNo >=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThan(String value) {
            addCriterion("AreaNo <", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThanOrEqualTo(String value) {
            addCriterion("AreaNo <=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLike(String value) {
            addCriterion("AreaNo like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotLike(String value) {
            addCriterion("AreaNo not like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoIn(List<String> values) {
            addCriterion("AreaNo in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotIn(List<String> values) {
            addCriterion("AreaNo not in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoBetween(String value1, String value2) {
            addCriterion("AreaNo between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotBetween(String value1, String value2) {
            addCriterion("AreaNo not between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNull() {
            addCriterion("PYCode is null");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNotNull() {
            addCriterion("PYCode is not null");
            return (Criteria) this;
        }

        public Criteria andPycodeEqualTo(String value) {
            addCriterion("PYCode =", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotEqualTo(String value) {
            addCriterion("PYCode <>", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThan(String value) {
            addCriterion("PYCode >", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThanOrEqualTo(String value) {
            addCriterion("PYCode >=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThan(String value) {
            addCriterion("PYCode <", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThanOrEqualTo(String value) {
            addCriterion("PYCode <=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLike(String value) {
            addCriterion("PYCode like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotLike(String value) {
            addCriterion("PYCode not like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeIn(List<String> values) {
            addCriterion("PYCode in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotIn(List<String> values) {
            addCriterion("PYCode not in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeBetween(String value1, String value2) {
            addCriterion("PYCode between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotBetween(String value1, String value2) {
            addCriterion("PYCode not between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andChairmanIsNull() {
            addCriterion("Chairman is null");
            return (Criteria) this;
        }

        public Criteria andChairmanIsNotNull() {
            addCriterion("Chairman is not null");
            return (Criteria) this;
        }

        public Criteria andChairmanEqualTo(String value) {
            addCriterion("Chairman =", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotEqualTo(String value) {
            addCriterion("Chairman <>", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanGreaterThan(String value) {
            addCriterion("Chairman >", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanGreaterThanOrEqualTo(String value) {
            addCriterion("Chairman >=", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLessThan(String value) {
            addCriterion("Chairman <", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLessThanOrEqualTo(String value) {
            addCriterion("Chairman <=", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLike(String value) {
            addCriterion("Chairman like", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotLike(String value) {
            addCriterion("Chairman not like", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanIn(List<String> values) {
            addCriterion("Chairman in", values, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotIn(List<String> values) {
            addCriterion("Chairman not in", values, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanBetween(String value1, String value2) {
            addCriterion("Chairman between", value1, value2, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotBetween(String value1, String value2) {
            addCriterion("Chairman not between", value1, value2, "chairman");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andHttpIsNull() {
            addCriterion("Http is null");
            return (Criteria) this;
        }

        public Criteria andHttpIsNotNull() {
            addCriterion("Http is not null");
            return (Criteria) this;
        }

        public Criteria andHttpEqualTo(String value) {
            addCriterion("Http =", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotEqualTo(String value) {
            addCriterion("Http <>", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpGreaterThan(String value) {
            addCriterion("Http >", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpGreaterThanOrEqualTo(String value) {
            addCriterion("Http >=", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpLessThan(String value) {
            addCriterion("Http <", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpLessThanOrEqualTo(String value) {
            addCriterion("Http <=", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpLike(String value) {
            addCriterion("Http like", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotLike(String value) {
            addCriterion("Http not like", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpIn(List<String> values) {
            addCriterion("Http in", values, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotIn(List<String> values) {
            addCriterion("Http not in", values, "http");
            return (Criteria) this;
        }

        public Criteria andHttpBetween(String value1, String value2) {
            addCriterion("Http between", value1, value2, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotBetween(String value1, String value2) {
            addCriterion("Http not between", value1, value2, "http");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("PostCode is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("PostCode is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("PostCode =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("PostCode <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("PostCode >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("PostCode >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("PostCode <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("PostCode <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("PostCode like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("PostCode not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("PostCode in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("PostCode not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("PostCode between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("PostCode not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNull() {
            addCriterion("Telephone is null");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNotNull() {
            addCriterion("Telephone is not null");
            return (Criteria) this;
        }

        public Criteria andTelephoneEqualTo(String value) {
            addCriterion("Telephone =", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotEqualTo(String value) {
            addCriterion("Telephone <>", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThan(String value) {
            addCriterion("Telephone >", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("Telephone >=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThan(String value) {
            addCriterion("Telephone <", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThanOrEqualTo(String value) {
            addCriterion("Telephone <=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLike(String value) {
            addCriterion("Telephone like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotLike(String value) {
            addCriterion("Telephone not like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneIn(List<String> values) {
            addCriterion("Telephone in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotIn(List<String> values) {
            addCriterion("Telephone not in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneBetween(String value1, String value2) {
            addCriterion("Telephone between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotBetween(String value1, String value2) {
            addCriterion("Telephone not between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("Mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("Mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("Mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("Mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("Mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("Mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("Mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("Mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("Mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("Mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("Mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("Mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("Mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("Mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("Fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("Fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("Fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("Fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("Fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("Fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("Fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("Fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("Fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("Fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("Fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("Fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("Fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("Fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("Email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("Email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("Email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("Email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("Email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("Email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("Email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("Email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("Email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("Email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("Email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("Email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("Email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("Email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andBalancecodeIsNull() {
            addCriterion("BalanceCode is null");
            return (Criteria) this;
        }

        public Criteria andBalancecodeIsNotNull() {
            addCriterion("BalanceCode is not null");
            return (Criteria) this;
        }

        public Criteria andBalancecodeEqualTo(String value) {
            addCriterion("BalanceCode =", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotEqualTo(String value) {
            addCriterion("BalanceCode <>", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeGreaterThan(String value) {
            addCriterion("BalanceCode >", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeGreaterThanOrEqualTo(String value) {
            addCriterion("BalanceCode >=", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeLessThan(String value) {
            addCriterion("BalanceCode <", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeLessThanOrEqualTo(String value) {
            addCriterion("BalanceCode <=", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeLike(String value) {
            addCriterion("BalanceCode like", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotLike(String value) {
            addCriterion("BalanceCode not like", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeIn(List<String> values) {
            addCriterion("BalanceCode in", values, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotIn(List<String> values) {
            addCriterion("BalanceCode not in", values, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeBetween(String value1, String value2) {
            addCriterion("BalanceCode between", value1, value2, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotBetween(String value1, String value2) {
            addCriterion("BalanceCode not between", value1, value2, "balancecode");
            return (Criteria) this;
        }

        public Criteria andTaxnoIsNull() {
            addCriterion("TaxNo is null");
            return (Criteria) this;
        }

        public Criteria andTaxnoIsNotNull() {
            addCriterion("TaxNo is not null");
            return (Criteria) this;
        }

        public Criteria andTaxnoEqualTo(String value) {
            addCriterion("TaxNo =", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotEqualTo(String value) {
            addCriterion("TaxNo <>", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoGreaterThan(String value) {
            addCriterion("TaxNo >", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoGreaterThanOrEqualTo(String value) {
            addCriterion("TaxNo >=", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLessThan(String value) {
            addCriterion("TaxNo <", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLessThanOrEqualTo(String value) {
            addCriterion("TaxNo <=", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLike(String value) {
            addCriterion("TaxNo like", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotLike(String value) {
            addCriterion("TaxNo not like", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoIn(List<String> values) {
            addCriterion("TaxNo in", values, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotIn(List<String> values) {
            addCriterion("TaxNo not in", values, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoBetween(String value1, String value2) {
            addCriterion("TaxNo between", value1, value2, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotBetween(String value1, String value2) {
            addCriterion("TaxNo not between", value1, value2, "taxno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIsNull() {
            addCriterion("BankAccNo is null");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIsNotNull() {
            addCriterion("BankAccNo is not null");
            return (Criteria) this;
        }

        public Criteria andBankaccnoEqualTo(String value) {
            addCriterion("BankAccNo =", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotEqualTo(String value) {
            addCriterion("BankAccNo <>", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoGreaterThan(String value) {
            addCriterion("BankAccNo >", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoGreaterThanOrEqualTo(String value) {
            addCriterion("BankAccNo >=", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLessThan(String value) {
            addCriterion("BankAccNo <", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLessThanOrEqualTo(String value) {
            addCriterion("BankAccNo <=", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLike(String value) {
            addCriterion("BankAccNo like", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotLike(String value) {
            addCriterion("BankAccNo not like", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIn(List<String> values) {
            addCriterion("BankAccNo in", values, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotIn(List<String> values) {
            addCriterion("BankAccNo not in", values, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoBetween(String value1, String value2) {
            addCriterion("BankAccNo between", value1, value2, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotBetween(String value1, String value2) {
            addCriterion("BankAccNo not between", value1, value2, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankIsNull() {
            addCriterion("Bank is null");
            return (Criteria) this;
        }

        public Criteria andBankIsNotNull() {
            addCriterion("Bank is not null");
            return (Criteria) this;
        }

        public Criteria andBankEqualTo(String value) {
            addCriterion("Bank =", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotEqualTo(String value) {
            addCriterion("Bank <>", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankGreaterThan(String value) {
            addCriterion("Bank >", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankGreaterThanOrEqualTo(String value) {
            addCriterion("Bank >=", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLessThan(String value) {
            addCriterion("Bank <", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLessThanOrEqualTo(String value) {
            addCriterion("Bank <=", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLike(String value) {
            addCriterion("Bank like", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotLike(String value) {
            addCriterion("Bank not like", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankIn(List<String> values) {
            addCriterion("Bank in", values, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotIn(List<String> values) {
            addCriterion("Bank not in", values, "bank");
            return (Criteria) this;
        }

        public Criteria andBankBetween(String value1, String value2) {
            addCriterion("Bank between", value1, value2, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotBetween(String value1, String value2) {
            addCriterion("Bank not between", value1, value2, "bank");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysIsNull() {
            addCriterion("DeliverDays is null");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysIsNotNull() {
            addCriterion("DeliverDays is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysEqualTo(Integer value) {
            addCriterion("DeliverDays =", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysNotEqualTo(Integer value) {
            addCriterion("DeliverDays <>", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysGreaterThan(Integer value) {
            addCriterion("DeliverDays >", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("DeliverDays >=", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysLessThan(Integer value) {
            addCriterion("DeliverDays <", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysLessThanOrEqualTo(Integer value) {
            addCriterion("DeliverDays <=", value, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysIn(List<Integer> values) {
            addCriterion("DeliverDays in", values, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysNotIn(List<Integer> values) {
            addCriterion("DeliverDays not in", values, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysBetween(Integer value1, Integer value2) {
            addCriterion("DeliverDays between", value1, value2, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andDeliverdaysNotBetween(Integer value1, Integer value2) {
            addCriterion("DeliverDays not between", value1, value2, "deliverdays");
            return (Criteria) this;
        }

        public Criteria andMinsendIsNull() {
            addCriterion("MinSend is null");
            return (Criteria) this;
        }

        public Criteria andMinsendIsNotNull() {
            addCriterion("MinSend is not null");
            return (Criteria) this;
        }

        public Criteria andMinsendEqualTo(Integer value) {
            addCriterion("MinSend =", value, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendNotEqualTo(Integer value) {
            addCriterion("MinSend <>", value, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendGreaterThan(Integer value) {
            addCriterion("MinSend >", value, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendGreaterThanOrEqualTo(Integer value) {
            addCriterion("MinSend >=", value, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendLessThan(Integer value) {
            addCriterion("MinSend <", value, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendLessThanOrEqualTo(Integer value) {
            addCriterion("MinSend <=", value, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendIn(List<Integer> values) {
            addCriterion("MinSend in", values, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendNotIn(List<Integer> values) {
            addCriterion("MinSend not in", values, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendBetween(Integer value1, Integer value2) {
            addCriterion("MinSend between", value1, value2, "minsend");
            return (Criteria) this;
        }

        public Criteria andMinsendNotBetween(Integer value1, Integer value2) {
            addCriterion("MinSend not between", value1, value2, "minsend");
            return (Criteria) this;
        }

        public Criteria andPocancelIsNull() {
            addCriterion("POCancel is null");
            return (Criteria) this;
        }

        public Criteria andPocancelIsNotNull() {
            addCriterion("POCancel is not null");
            return (Criteria) this;
        }

        public Criteria andPocancelEqualTo(Integer value) {
            addCriterion("POCancel =", value, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelNotEqualTo(Integer value) {
            addCriterion("POCancel <>", value, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelGreaterThan(Integer value) {
            addCriterion("POCancel >", value, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelGreaterThanOrEqualTo(Integer value) {
            addCriterion("POCancel >=", value, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelLessThan(Integer value) {
            addCriterion("POCancel <", value, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelLessThanOrEqualTo(Integer value) {
            addCriterion("POCancel <=", value, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelIn(List<Integer> values) {
            addCriterion("POCancel in", values, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelNotIn(List<Integer> values) {
            addCriterion("POCancel not in", values, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelBetween(Integer value1, Integer value2) {
            addCriterion("POCancel between", value1, value2, "pocancel");
            return (Criteria) this;
        }

        public Criteria andPocancelNotBetween(Integer value1, Integer value2) {
            addCriterion("POCancel not between", value1, value2, "pocancel");
            return (Criteria) this;
        }

        public Criteria andVendortypeIsNull() {
            addCriterion("VendorType is null");
            return (Criteria) this;
        }

        public Criteria andVendortypeIsNotNull() {
            addCriterion("VendorType is not null");
            return (Criteria) this;
        }

        public Criteria andVendortypeEqualTo(String value) {
            addCriterion("VendorType =", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeNotEqualTo(String value) {
            addCriterion("VendorType <>", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeGreaterThan(String value) {
            addCriterion("VendorType >", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeGreaterThanOrEqualTo(String value) {
            addCriterion("VendorType >=", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeLessThan(String value) {
            addCriterion("VendorType <", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeLessThanOrEqualTo(String value) {
            addCriterion("VendorType <=", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeLike(String value) {
            addCriterion("VendorType like", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeNotLike(String value) {
            addCriterion("VendorType not like", value, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeIn(List<String> values) {
            addCriterion("VendorType in", values, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeNotIn(List<String> values) {
            addCriterion("VendorType not in", values, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeBetween(String value1, String value2) {
            addCriterion("VendorType between", value1, value2, "vendortype");
            return (Criteria) this;
        }

        public Criteria andVendortypeNotBetween(String value1, String value2) {
            addCriterion("VendorType not between", value1, value2, "vendortype");
            return (Criteria) this;
        }

        public Criteria andStopdateIsNull() {
            addCriterion("StopDate is null");
            return (Criteria) this;
        }

        public Criteria andStopdateIsNotNull() {
            addCriterion("StopDate is not null");
            return (Criteria) this;
        }

        public Criteria andStopdateEqualTo(Date value) {
            addCriterion("StopDate =", value, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateNotEqualTo(Date value) {
            addCriterion("StopDate <>", value, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateGreaterThan(Date value) {
            addCriterion("StopDate >", value, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateGreaterThanOrEqualTo(Date value) {
            addCriterion("StopDate >=", value, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateLessThan(Date value) {
            addCriterion("StopDate <", value, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateLessThanOrEqualTo(Date value) {
            addCriterion("StopDate <=", value, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateIn(List<Date> values) {
            addCriterion("StopDate in", values, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateNotIn(List<Date> values) {
            addCriterion("StopDate not in", values, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateBetween(Date value1, Date value2) {
            addCriterion("StopDate between", value1, value2, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopdateNotBetween(Date value1, Date value2) {
            addCriterion("StopDate not between", value1, value2, "stopdate");
            return (Criteria) this;
        }

        public Criteria andStopreasonIsNull() {
            addCriterion("StopReason is null");
            return (Criteria) this;
        }

        public Criteria andStopreasonIsNotNull() {
            addCriterion("StopReason is not null");
            return (Criteria) this;
        }

        public Criteria andStopreasonEqualTo(String value) {
            addCriterion("StopReason =", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotEqualTo(String value) {
            addCriterion("StopReason <>", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonGreaterThan(String value) {
            addCriterion("StopReason >", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonGreaterThanOrEqualTo(String value) {
            addCriterion("StopReason >=", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonLessThan(String value) {
            addCriterion("StopReason <", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonLessThanOrEqualTo(String value) {
            addCriterion("StopReason <=", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonLike(String value) {
            addCriterion("StopReason like", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotLike(String value) {
            addCriterion("StopReason not like", value, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonIn(List<String> values) {
            addCriterion("StopReason in", values, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotIn(List<String> values) {
            addCriterion("StopReason not in", values, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonBetween(String value1, String value2) {
            addCriterion("StopReason between", value1, value2, "stopreason");
            return (Criteria) this;
        }

        public Criteria andStopreasonNotBetween(String value1, String value2) {
            addCriterion("StopReason not between", value1, value2, "stopreason");
            return (Criteria) this;
        }

        public Criteria andAbandondateIsNull() {
            addCriterion("AbandonDate is null");
            return (Criteria) this;
        }

        public Criteria andAbandondateIsNotNull() {
            addCriterion("AbandonDate is not null");
            return (Criteria) this;
        }

        public Criteria andAbandondateEqualTo(Date value) {
            addCriterion("AbandonDate =", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateNotEqualTo(Date value) {
            addCriterion("AbandonDate <>", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateGreaterThan(Date value) {
            addCriterion("AbandonDate >", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateGreaterThanOrEqualTo(Date value) {
            addCriterion("AbandonDate >=", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateLessThan(Date value) {
            addCriterion("AbandonDate <", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateLessThanOrEqualTo(Date value) {
            addCriterion("AbandonDate <=", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateIn(List<Date> values) {
            addCriterion("AbandonDate in", values, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateNotIn(List<Date> values) {
            addCriterion("AbandonDate not in", values, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateBetween(Date value1, Date value2) {
            addCriterion("AbandonDate between", value1, value2, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateNotBetween(Date value1, Date value2) {
            addCriterion("AbandonDate not between", value1, value2, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysIsNull() {
            addCriterion("AbandonWhys is null");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysIsNotNull() {
            addCriterion("AbandonWhys is not null");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysEqualTo(String value) {
            addCriterion("AbandonWhys =", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotEqualTo(String value) {
            addCriterion("AbandonWhys <>", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysGreaterThan(String value) {
            addCriterion("AbandonWhys >", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysGreaterThanOrEqualTo(String value) {
            addCriterion("AbandonWhys >=", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysLessThan(String value) {
            addCriterion("AbandonWhys <", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysLessThanOrEqualTo(String value) {
            addCriterion("AbandonWhys <=", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysLike(String value) {
            addCriterion("AbandonWhys like", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotLike(String value) {
            addCriterion("AbandonWhys not like", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysIn(List<String> values) {
            addCriterion("AbandonWhys in", values, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotIn(List<String> values) {
            addCriterion("AbandonWhys not in", values, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysBetween(String value1, String value2) {
            addCriterion("AbandonWhys between", value1, value2, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotBetween(String value1, String value2) {
            addCriterion("AbandonWhys not between", value1, value2, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andBegindateIsNull() {
            addCriterion("BeginDate is null");
            return (Criteria) this;
        }

        public Criteria andBegindateIsNotNull() {
            addCriterion("BeginDate is not null");
            return (Criteria) this;
        }

        public Criteria andBegindateEqualTo(Date value) {
            addCriterion("BeginDate =", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotEqualTo(Date value) {
            addCriterion("BeginDate <>", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateGreaterThan(Date value) {
            addCriterion("BeginDate >", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateGreaterThanOrEqualTo(Date value) {
            addCriterion("BeginDate >=", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateLessThan(Date value) {
            addCriterion("BeginDate <", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateLessThanOrEqualTo(Date value) {
            addCriterion("BeginDate <=", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateIn(List<Date> values) {
            addCriterion("BeginDate in", values, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotIn(List<Date> values) {
            addCriterion("BeginDate not in", values, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateBetween(Date value1, Date value2) {
            addCriterion("BeginDate between", value1, value2, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotBetween(Date value1, Date value2) {
            addCriterion("BeginDate not between", value1, value2, "begindate");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNull() {
            addCriterion("EndDate is null");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNotNull() {
            addCriterion("EndDate is not null");
            return (Criteria) this;
        }

        public Criteria andEnddateEqualTo(Date value) {
            addCriterion("EndDate =", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotEqualTo(Date value) {
            addCriterion("EndDate <>", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThan(Date value) {
            addCriterion("EndDate >", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThanOrEqualTo(Date value) {
            addCriterion("EndDate >=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThan(Date value) {
            addCriterion("EndDate <", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThanOrEqualTo(Date value) {
            addCriterion("EndDate <=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateIn(List<Date> values) {
            addCriterion("EndDate in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotIn(List<Date> values) {
            addCriterion("EndDate not in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateBetween(Date value1, Date value2) {
            addCriterion("EndDate between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotBetween(Date value1, Date value2) {
            addCriterion("EndDate not between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andRebatebaseIsNull() {
            addCriterion("RebateBase is null");
            return (Criteria) this;
        }

        public Criteria andRebatebaseIsNotNull() {
            addCriterion("RebateBase is not null");
            return (Criteria) this;
        }

        public Criteria andRebatebaseEqualTo(BigDecimal value) {
            addCriterion("RebateBase =", value, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseNotEqualTo(BigDecimal value) {
            addCriterion("RebateBase <>", value, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseGreaterThan(BigDecimal value) {
            addCriterion("RebateBase >", value, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RebateBase >=", value, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseLessThan(BigDecimal value) {
            addCriterion("RebateBase <", value, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RebateBase <=", value, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseIn(List<BigDecimal> values) {
            addCriterion("RebateBase in", values, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseNotIn(List<BigDecimal> values) {
            addCriterion("RebateBase not in", values, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RebateBase between", value1, value2, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andRebatebaseNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RebateBase not between", value1, value2, "rebatebase");
            return (Criteria) this;
        }

        public Criteria andBalancecycIsNull() {
            addCriterion("BalanceCyc is null");
            return (Criteria) this;
        }

        public Criteria andBalancecycIsNotNull() {
            addCriterion("BalanceCyc is not null");
            return (Criteria) this;
        }

        public Criteria andBalancecycEqualTo(Integer value) {
            addCriterion("BalanceCyc =", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycNotEqualTo(Integer value) {
            addCriterion("BalanceCyc <>", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycGreaterThan(Integer value) {
            addCriterion("BalanceCyc >", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycGreaterThanOrEqualTo(Integer value) {
            addCriterion("BalanceCyc >=", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycLessThan(Integer value) {
            addCriterion("BalanceCyc <", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycLessThanOrEqualTo(Integer value) {
            addCriterion("BalanceCyc <=", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycIn(List<Integer> values) {
            addCriterion("BalanceCyc in", values, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycNotIn(List<Integer> values) {
            addCriterion("BalanceCyc not in", values, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycBetween(Integer value1, Integer value2) {
            addCriterion("BalanceCyc between", value1, value2, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycNotBetween(Integer value1, Integer value2) {
            addCriterion("BalanceCyc not between", value1, value2, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andLoginnameIsNull() {
            addCriterion("LoginName is null");
            return (Criteria) this;
        }

        public Criteria andLoginnameIsNotNull() {
            addCriterion("LoginName is not null");
            return (Criteria) this;
        }

        public Criteria andLoginnameEqualTo(String value) {
            addCriterion("LoginName =", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameNotEqualTo(String value) {
            addCriterion("LoginName <>", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameGreaterThan(String value) {
            addCriterion("LoginName >", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameGreaterThanOrEqualTo(String value) {
            addCriterion("LoginName >=", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameLessThan(String value) {
            addCriterion("LoginName <", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameLessThanOrEqualTo(String value) {
            addCriterion("LoginName <=", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameLike(String value) {
            addCriterion("LoginName like", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameNotLike(String value) {
            addCriterion("LoginName not like", value, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameIn(List<String> values) {
            addCriterion("LoginName in", values, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameNotIn(List<String> values) {
            addCriterion("LoginName not in", values, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameBetween(String value1, String value2) {
            addCriterion("LoginName between", value1, value2, "loginname");
            return (Criteria) this;
        }

        public Criteria andLoginnameNotBetween(String value1, String value2) {
            addCriterion("LoginName not between", value1, value2, "loginname");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("Password is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("Password is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("Password =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("Password <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("Password >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("Password >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("Password <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("Password <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("Password like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("Password not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("Password in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("Password not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("Password between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("Password not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andEdimodeIsNull() {
            addCriterion("EDIMode is null");
            return (Criteria) this;
        }

        public Criteria andEdimodeIsNotNull() {
            addCriterion("EDIMode is not null");
            return (Criteria) this;
        }

        public Criteria andEdimodeEqualTo(String value) {
            addCriterion("EDIMode =", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotEqualTo(String value) {
            addCriterion("EDIMode <>", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeGreaterThan(String value) {
            addCriterion("EDIMode >", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeGreaterThanOrEqualTo(String value) {
            addCriterion("EDIMode >=", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeLessThan(String value) {
            addCriterion("EDIMode <", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeLessThanOrEqualTo(String value) {
            addCriterion("EDIMode <=", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeLike(String value) {
            addCriterion("EDIMode like", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotLike(String value) {
            addCriterion("EDIMode not like", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeIn(List<String> values) {
            addCriterion("EDIMode in", values, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotIn(List<String> values) {
            addCriterion("EDIMode not in", values, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeBetween(String value1, String value2) {
            addCriterion("EDIMode between", value1, value2, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotBetween(String value1, String value2) {
            addCriterion("EDIMode not between", value1, value2, "edimode");
            return (Criteria) this;
        }

        public Criteria andPorateIsNull() {
            addCriterion("PORate is null");
            return (Criteria) this;
        }

        public Criteria andPorateIsNotNull() {
            addCriterion("PORate is not null");
            return (Criteria) this;
        }

        public Criteria andPorateEqualTo(BigDecimal value) {
            addCriterion("PORate =", value, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateNotEqualTo(BigDecimal value) {
            addCriterion("PORate <>", value, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateGreaterThan(BigDecimal value) {
            addCriterion("PORate >", value, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PORate >=", value, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateLessThan(BigDecimal value) {
            addCriterion("PORate <", value, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PORate <=", value, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateIn(List<BigDecimal> values) {
            addCriterion("PORate in", values, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateNotIn(List<BigDecimal> values) {
            addCriterion("PORate not in", values, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PORate between", value1, value2, "porate");
            return (Criteria) this;
        }

        public Criteria andPorateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PORate not between", value1, value2, "porate");
            return (Criteria) this;
        }

        public Criteria andVendorrankIsNull() {
            addCriterion("VendorRank is null");
            return (Criteria) this;
        }

        public Criteria andVendorrankIsNotNull() {
            addCriterion("VendorRank is not null");
            return (Criteria) this;
        }

        public Criteria andVendorrankEqualTo(String value) {
            addCriterion("VendorRank =", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankNotEqualTo(String value) {
            addCriterion("VendorRank <>", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankGreaterThan(String value) {
            addCriterion("VendorRank >", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankGreaterThanOrEqualTo(String value) {
            addCriterion("VendorRank >=", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankLessThan(String value) {
            addCriterion("VendorRank <", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankLessThanOrEqualTo(String value) {
            addCriterion("VendorRank <=", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankLike(String value) {
            addCriterion("VendorRank like", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankNotLike(String value) {
            addCriterion("VendorRank not like", value, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankIn(List<String> values) {
            addCriterion("VendorRank in", values, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankNotIn(List<String> values) {
            addCriterion("VendorRank not in", values, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankBetween(String value1, String value2) {
            addCriterion("VendorRank between", value1, value2, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andVendorrankNotBetween(String value1, String value2) {
            addCriterion("VendorRank not between", value1, value2, "vendorrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankIsNull() {
            addCriterion("OfferRank is null");
            return (Criteria) this;
        }

        public Criteria andOfferrankIsNotNull() {
            addCriterion("OfferRank is not null");
            return (Criteria) this;
        }

        public Criteria andOfferrankEqualTo(Integer value) {
            addCriterion("OfferRank =", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankNotEqualTo(Integer value) {
            addCriterion("OfferRank <>", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankGreaterThan(Integer value) {
            addCriterion("OfferRank >", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankGreaterThanOrEqualTo(Integer value) {
            addCriterion("OfferRank >=", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankLessThan(Integer value) {
            addCriterion("OfferRank <", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankLessThanOrEqualTo(Integer value) {
            addCriterion("OfferRank <=", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankIn(List<Integer> values) {
            addCriterion("OfferRank in", values, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankNotIn(List<Integer> values) {
            addCriterion("OfferRank not in", values, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankBetween(Integer value1, Integer value2) {
            addCriterion("OfferRank between", value1, value2, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankNotBetween(Integer value1, Integer value2) {
            addCriterion("OfferRank not between", value1, value2, "offerrank");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNull() {
            addCriterion("Business is null");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNotNull() {
            addCriterion("Business is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessEqualTo(String value) {
            addCriterion("Business =", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotEqualTo(String value) {
            addCriterion("Business <>", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThan(String value) {
            addCriterion("Business >", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThanOrEqualTo(String value) {
            addCriterion("Business >=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThan(String value) {
            addCriterion("Business <", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThanOrEqualTo(String value) {
            addCriterion("Business <=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLike(String value) {
            addCriterion("Business like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotLike(String value) {
            addCriterion("Business not like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessIn(List<String> values) {
            addCriterion("Business in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotIn(List<String> values) {
            addCriterion("Business not in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessBetween(String value1, String value2) {
            addCriterion("Business between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotBetween(String value1, String value2) {
            addCriterion("Business not between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("Status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("Status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("Status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("Status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("Status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("Status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("Status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("Status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("Status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("Status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("Status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("Status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("Status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("Status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNull() {
            addCriterion("NewUpdate is null");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNotNull() {
            addCriterion("NewUpdate is not null");
            return (Criteria) this;
        }

        public Criteria andNewupdateEqualTo(Date value) {
            addCriterion("NewUpdate =", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotEqualTo(Date value) {
            addCriterion("NewUpdate <>", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThan(Date value) {
            addCriterion("NewUpdate >", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThanOrEqualTo(Date value) {
            addCriterion("NewUpdate >=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThan(Date value) {
            addCriterion("NewUpdate <", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThanOrEqualTo(Date value) {
            addCriterion("NewUpdate <=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateIn(List<Date> values) {
            addCriterion("NewUpdate in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotIn(List<Date> values) {
            addCriterion("NewUpdate not in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateBetween(Date value1, Date value2) {
            addCriterion("NewUpdate between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotBetween(Date value1, Date value2) {
            addCriterion("NewUpdate not between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeIsNull() {
            addCriterion("RebatePayMode is null");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeIsNotNull() {
            addCriterion("RebatePayMode is not null");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeEqualTo(String value) {
            addCriterion("RebatePayMode =", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotEqualTo(String value) {
            addCriterion("RebatePayMode <>", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeGreaterThan(String value) {
            addCriterion("RebatePayMode >", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeGreaterThanOrEqualTo(String value) {
            addCriterion("RebatePayMode >=", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeLessThan(String value) {
            addCriterion("RebatePayMode <", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeLessThanOrEqualTo(String value) {
            addCriterion("RebatePayMode <=", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeLike(String value) {
            addCriterion("RebatePayMode like", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotLike(String value) {
            addCriterion("RebatePayMode not like", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeIn(List<String> values) {
            addCriterion("RebatePayMode in", values, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotIn(List<String> values) {
            addCriterion("RebatePayMode not in", values, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeBetween(String value1, String value2) {
            addCriterion("RebatePayMode between", value1, value2, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotBetween(String value1, String value2) {
            addCriterion("RebatePayMode not between", value1, value2, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeIsNull() {
            addCriterion("RebateMode is null");
            return (Criteria) this;
        }

        public Criteria andRebatemodeIsNotNull() {
            addCriterion("RebateMode is not null");
            return (Criteria) this;
        }

        public Criteria andRebatemodeEqualTo(String value) {
            addCriterion("RebateMode =", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotEqualTo(String value) {
            addCriterion("RebateMode <>", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeGreaterThan(String value) {
            addCriterion("RebateMode >", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeGreaterThanOrEqualTo(String value) {
            addCriterion("RebateMode >=", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeLessThan(String value) {
            addCriterion("RebateMode <", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeLessThanOrEqualTo(String value) {
            addCriterion("RebateMode <=", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeLike(String value) {
            addCriterion("RebateMode like", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotLike(String value) {
            addCriterion("RebateMode not like", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeIn(List<String> values) {
            addCriterion("RebateMode in", values, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotIn(List<String> values) {
            addCriterion("RebateMode not in", values, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeBetween(String value1, String value2) {
            addCriterion("RebateMode between", value1, value2, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotBetween(String value1, String value2) {
            addCriterion("RebateMode not between", value1, value2, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebateIsNull() {
            addCriterion("Rebate is null");
            return (Criteria) this;
        }

        public Criteria andRebateIsNotNull() {
            addCriterion("Rebate is not null");
            return (Criteria) this;
        }

        public Criteria andRebateEqualTo(BigDecimal value) {
            addCriterion("Rebate =", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotEqualTo(BigDecimal value) {
            addCriterion("Rebate <>", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateGreaterThan(BigDecimal value) {
            addCriterion("Rebate >", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate >=", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateLessThan(BigDecimal value) {
            addCriterion("Rebate <", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate <=", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateIn(List<BigDecimal> values) {
            addCriterion("Rebate in", values, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotIn(List<BigDecimal> values) {
            addCriterion("Rebate not in", values, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate between", value1, value2, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate not between", value1, value2, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebatecondIsNull() {
            addCriterion("RebateCond is null");
            return (Criteria) this;
        }

        public Criteria andRebatecondIsNotNull() {
            addCriterion("RebateCond is not null");
            return (Criteria) this;
        }

        public Criteria andRebatecondEqualTo(BigDecimal value) {
            addCriterion("RebateCond =", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondNotEqualTo(BigDecimal value) {
            addCriterion("RebateCond <>", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondGreaterThan(BigDecimal value) {
            addCriterion("RebateCond >", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RebateCond >=", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondLessThan(BigDecimal value) {
            addCriterion("RebateCond <", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RebateCond <=", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondIn(List<BigDecimal> values) {
            addCriterion("RebateCond in", values, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondNotIn(List<BigDecimal> values) {
            addCriterion("RebateCond not in", values, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RebateCond between", value1, value2, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RebateCond not between", value1, value2, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebate2IsNull() {
            addCriterion("Rebate2 is null");
            return (Criteria) this;
        }

        public Criteria andRebate2IsNotNull() {
            addCriterion("Rebate2 is not null");
            return (Criteria) this;
        }

        public Criteria andRebate2EqualTo(BigDecimal value) {
            addCriterion("Rebate2 =", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2NotEqualTo(BigDecimal value) {
            addCriterion("Rebate2 <>", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2GreaterThan(BigDecimal value) {
            addCriterion("Rebate2 >", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate2 >=", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2LessThan(BigDecimal value) {
            addCriterion("Rebate2 <", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate2 <=", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2In(List<BigDecimal> values) {
            addCriterion("Rebate2 in", values, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2NotIn(List<BigDecimal> values) {
            addCriterion("Rebate2 not in", values, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate2 between", value1, value2, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate2 not between", value1, value2, "rebate2");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitIsNull() {
            addCriterion("NotstockLimit is null");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitIsNotNull() {
            addCriterion("NotstockLimit is not null");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitEqualTo(String value) {
            addCriterion("NotstockLimit =", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitNotEqualTo(String value) {
            addCriterion("NotstockLimit <>", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitGreaterThan(String value) {
            addCriterion("NotstockLimit >", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitGreaterThanOrEqualTo(String value) {
            addCriterion("NotstockLimit >=", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitLessThan(String value) {
            addCriterion("NotstockLimit <", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitLessThanOrEqualTo(String value) {
            addCriterion("NotstockLimit <=", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitLike(String value) {
            addCriterion("NotstockLimit like", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitNotLike(String value) {
            addCriterion("NotstockLimit not like", value, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitIn(List<String> values) {
            addCriterion("NotstockLimit in", values, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitNotIn(List<String> values) {
            addCriterion("NotstockLimit not in", values, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitBetween(String value1, String value2) {
            addCriterion("NotstockLimit between", value1, value2, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andNotstocklimitNotBetween(String value1, String value2) {
            addCriterion("NotstockLimit not between", value1, value2, "notstocklimit");
            return (Criteria) this;
        }

        public Criteria andDepositIsNull() {
            addCriterion("Deposit is null");
            return (Criteria) this;
        }

        public Criteria andDepositIsNotNull() {
            addCriterion("Deposit is not null");
            return (Criteria) this;
        }

        public Criteria andDepositEqualTo(BigDecimal value) {
            addCriterion("Deposit =", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositNotEqualTo(BigDecimal value) {
            addCriterion("Deposit <>", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositGreaterThan(BigDecimal value) {
            addCriterion("Deposit >", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Deposit >=", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositLessThan(BigDecimal value) {
            addCriterion("Deposit <", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Deposit <=", value, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositIn(List<BigDecimal> values) {
            addCriterion("Deposit in", values, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositNotIn(List<BigDecimal> values) {
            addCriterion("Deposit not in", values, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Deposit between", value1, value2, "deposit");
            return (Criteria) this;
        }

        public Criteria andDepositNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Deposit not between", value1, value2, "deposit");
            return (Criteria) this;
        }

        public Criteria andCompratetypeIsNull() {
            addCriterion("CompRateType is null");
            return (Criteria) this;
        }

        public Criteria andCompratetypeIsNotNull() {
            addCriterion("CompRateType is not null");
            return (Criteria) this;
        }

        public Criteria andCompratetypeEqualTo(String value) {
            addCriterion("CompRateType =", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeNotEqualTo(String value) {
            addCriterion("CompRateType <>", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeGreaterThan(String value) {
            addCriterion("CompRateType >", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeGreaterThanOrEqualTo(String value) {
            addCriterion("CompRateType >=", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeLessThan(String value) {
            addCriterion("CompRateType <", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeLessThanOrEqualTo(String value) {
            addCriterion("CompRateType <=", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeLike(String value) {
            addCriterion("CompRateType like", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeNotLike(String value) {
            addCriterion("CompRateType not like", value, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeIn(List<String> values) {
            addCriterion("CompRateType in", values, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeNotIn(List<String> values) {
            addCriterion("CompRateType not in", values, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeBetween(String value1, String value2) {
            addCriterion("CompRateType between", value1, value2, "compratetype");
            return (Criteria) this;
        }

        public Criteria andCompratetypeNotBetween(String value1, String value2) {
            addCriterion("CompRateType not between", value1, value2, "compratetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeIsNull() {
            addCriterion("BalanceType is null");
            return (Criteria) this;
        }

        public Criteria andBalancetypeIsNotNull() {
            addCriterion("BalanceType is not null");
            return (Criteria) this;
        }

        public Criteria andBalancetypeEqualTo(String value) {
            addCriterion("BalanceType =", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotEqualTo(String value) {
            addCriterion("BalanceType <>", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeGreaterThan(String value) {
            addCriterion("BalanceType >", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeGreaterThanOrEqualTo(String value) {
            addCriterion("BalanceType >=", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeLessThan(String value) {
            addCriterion("BalanceType <", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeLessThanOrEqualTo(String value) {
            addCriterion("BalanceType <=", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeLike(String value) {
            addCriterion("BalanceType like", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotLike(String value) {
            addCriterion("BalanceType not like", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeIn(List<String> values) {
            addCriterion("BalanceType in", values, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotIn(List<String> values) {
            addCriterion("BalanceType not in", values, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeBetween(String value1, String value2) {
            addCriterion("BalanceType between", value1, value2, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotBetween(String value1, String value2) {
            addCriterion("BalanceType not between", value1, value2, "balancetype");
            return (Criteria) this;
        }

        public Criteria andIsbottomIsNull() {
            addCriterion("IsBottom is null");
            return (Criteria) this;
        }

        public Criteria andIsbottomIsNotNull() {
            addCriterion("IsBottom is not null");
            return (Criteria) this;
        }

        public Criteria andIsbottomEqualTo(String value) {
            addCriterion("IsBottom =", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomNotEqualTo(String value) {
            addCriterion("IsBottom <>", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomGreaterThan(String value) {
            addCriterion("IsBottom >", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomGreaterThanOrEqualTo(String value) {
            addCriterion("IsBottom >=", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomLessThan(String value) {
            addCriterion("IsBottom <", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomLessThanOrEqualTo(String value) {
            addCriterion("IsBottom <=", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomLike(String value) {
            addCriterion("IsBottom like", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomNotLike(String value) {
            addCriterion("IsBottom not like", value, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomIn(List<String> values) {
            addCriterion("IsBottom in", values, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomNotIn(List<String> values) {
            addCriterion("IsBottom not in", values, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomBetween(String value1, String value2) {
            addCriterion("IsBottom between", value1, value2, "isbottom");
            return (Criteria) this;
        }

        public Criteria andIsbottomNotBetween(String value1, String value2) {
            addCriterion("IsBottom not between", value1, value2, "isbottom");
            return (Criteria) this;
        }

        public Criteria andRebatetypeIsNull() {
            addCriterion("RebateType is null");
            return (Criteria) this;
        }

        public Criteria andRebatetypeIsNotNull() {
            addCriterion("RebateType is not null");
            return (Criteria) this;
        }

        public Criteria andRebatetypeEqualTo(String value) {
            addCriterion("RebateType =", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeNotEqualTo(String value) {
            addCriterion("RebateType <>", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeGreaterThan(String value) {
            addCriterion("RebateType >", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeGreaterThanOrEqualTo(String value) {
            addCriterion("RebateType >=", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeLessThan(String value) {
            addCriterion("RebateType <", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeLessThanOrEqualTo(String value) {
            addCriterion("RebateType <=", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeLike(String value) {
            addCriterion("RebateType like", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeNotLike(String value) {
            addCriterion("RebateType not like", value, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeIn(List<String> values) {
            addCriterion("RebateType in", values, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeNotIn(List<String> values) {
            addCriterion("RebateType not in", values, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeBetween(String value1, String value2) {
            addCriterion("RebateType between", value1, value2, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andRebatetypeNotBetween(String value1, String value2) {
            addCriterion("RebateType not between", value1, value2, "rebatetype");
            return (Criteria) this;
        }

        public Criteria andApportbottomIsNull() {
            addCriterion("ApportBottom is null");
            return (Criteria) this;
        }

        public Criteria andApportbottomIsNotNull() {
            addCriterion("ApportBottom is not null");
            return (Criteria) this;
        }

        public Criteria andApportbottomEqualTo(BigDecimal value) {
            addCriterion("ApportBottom =", value, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomNotEqualTo(BigDecimal value) {
            addCriterion("ApportBottom <>", value, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomGreaterThan(BigDecimal value) {
            addCriterion("ApportBottom >", value, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ApportBottom >=", value, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomLessThan(BigDecimal value) {
            addCriterion("ApportBottom <", value, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ApportBottom <=", value, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomIn(List<BigDecimal> values) {
            addCriterion("ApportBottom in", values, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomNotIn(List<BigDecimal> values) {
            addCriterion("ApportBottom not in", values, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ApportBottom between", value1, value2, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportbottomNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ApportBottom not between", value1, value2, "apportbottom");
            return (Criteria) this;
        }

        public Criteria andApportrateIsNull() {
            addCriterion("ApportRate is null");
            return (Criteria) this;
        }

        public Criteria andApportrateIsNotNull() {
            addCriterion("ApportRate is not null");
            return (Criteria) this;
        }

        public Criteria andApportrateEqualTo(BigDecimal value) {
            addCriterion("ApportRate =", value, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateNotEqualTo(BigDecimal value) {
            addCriterion("ApportRate <>", value, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateGreaterThan(BigDecimal value) {
            addCriterion("ApportRate >", value, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ApportRate >=", value, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateLessThan(BigDecimal value) {
            addCriterion("ApportRate <", value, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ApportRate <=", value, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateIn(List<BigDecimal> values) {
            addCriterion("ApportRate in", values, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateNotIn(List<BigDecimal> values) {
            addCriterion("ApportRate not in", values, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ApportRate between", value1, value2, "apportrate");
            return (Criteria) this;
        }

        public Criteria andApportrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ApportRate not between", value1, value2, "apportrate");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andFlooramtIsNull() {
            addCriterion("FloorAmt is null");
            return (Criteria) this;
        }

        public Criteria andFlooramtIsNotNull() {
            addCriterion("FloorAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFlooramtEqualTo(BigDecimal value) {
            addCriterion("FloorAmt =", value, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtNotEqualTo(BigDecimal value) {
            addCriterion("FloorAmt <>", value, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtGreaterThan(BigDecimal value) {
            addCriterion("FloorAmt >", value, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FloorAmt >=", value, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtLessThan(BigDecimal value) {
            addCriterion("FloorAmt <", value, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FloorAmt <=", value, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtIn(List<BigDecimal> values) {
            addCriterion("FloorAmt in", values, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtNotIn(List<BigDecimal> values) {
            addCriterion("FloorAmt not in", values, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FloorAmt between", value1, value2, "flooramt");
            return (Criteria) this;
        }

        public Criteria andFlooramtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FloorAmt not between", value1, value2, "flooramt");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagIsNull() {
            addCriterion("WebAccessFlag is null");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagIsNotNull() {
            addCriterion("WebAccessFlag is not null");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagEqualTo(String value) {
            addCriterion("WebAccessFlag =", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotEqualTo(String value) {
            addCriterion("WebAccessFlag <>", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagGreaterThan(String value) {
            addCriterion("WebAccessFlag >", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagGreaterThanOrEqualTo(String value) {
            addCriterion("WebAccessFlag >=", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagLessThan(String value) {
            addCriterion("WebAccessFlag <", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagLessThanOrEqualTo(String value) {
            addCriterion("WebAccessFlag <=", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagLike(String value) {
            addCriterion("WebAccessFlag like", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotLike(String value) {
            addCriterion("WebAccessFlag not like", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagIn(List<String> values) {
            addCriterion("WebAccessFlag in", values, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotIn(List<String> values) {
            addCriterion("WebAccessFlag not in", values, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagBetween(String value1, String value2) {
            addCriterion("WebAccessFlag between", value1, value2, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotBetween(String value1, String value2) {
            addCriterion("WebAccessFlag not between", value1, value2, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebopendateIsNull() {
            addCriterion("WebOpenDate is null");
            return (Criteria) this;
        }

        public Criteria andWebopendateIsNotNull() {
            addCriterion("WebOpenDate is not null");
            return (Criteria) this;
        }

        public Criteria andWebopendateEqualTo(Date value) {
            addCriterion("WebOpenDate =", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateNotEqualTo(Date value) {
            addCriterion("WebOpenDate <>", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateGreaterThan(Date value) {
            addCriterion("WebOpenDate >", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateGreaterThanOrEqualTo(Date value) {
            addCriterion("WebOpenDate >=", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateLessThan(Date value) {
            addCriterion("WebOpenDate <", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateLessThanOrEqualTo(Date value) {
            addCriterion("WebOpenDate <=", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateIn(List<Date> values) {
            addCriterion("WebOpenDate in", values, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateNotIn(List<Date> values) {
            addCriterion("WebOpenDate not in", values, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateBetween(Date value1, Date value2) {
            addCriterion("WebOpenDate between", value1, value2, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateNotBetween(Date value1, Date value2) {
            addCriterion("WebOpenDate not between", value1, value2, "webopendate");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("Source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("Source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("Source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("Source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("Source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("Source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("Source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("Source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("Source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("Source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("Source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("Source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("Source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("Source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeIsNull() {
            addCriterion("OrderDayMode is null");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeIsNotNull() {
            addCriterion("OrderDayMode is not null");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeEqualTo(String value) {
            addCriterion("OrderDayMode =", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeNotEqualTo(String value) {
            addCriterion("OrderDayMode <>", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeGreaterThan(String value) {
            addCriterion("OrderDayMode >", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeGreaterThanOrEqualTo(String value) {
            addCriterion("OrderDayMode >=", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeLessThan(String value) {
            addCriterion("OrderDayMode <", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeLessThanOrEqualTo(String value) {
            addCriterion("OrderDayMode <=", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeLike(String value) {
            addCriterion("OrderDayMode like", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeNotLike(String value) {
            addCriterion("OrderDayMode not like", value, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeIn(List<String> values) {
            addCriterion("OrderDayMode in", values, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeNotIn(List<String> values) {
            addCriterion("OrderDayMode not in", values, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeBetween(String value1, String value2) {
            addCriterion("OrderDayMode between", value1, value2, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaymodeNotBetween(String value1, String value2) {
            addCriterion("OrderDayMode not between", value1, value2, "orderdaymode");
            return (Criteria) this;
        }

        public Criteria andOrderdaysIsNull() {
            addCriterion("OrderDays is null");
            return (Criteria) this;
        }

        public Criteria andOrderdaysIsNotNull() {
            addCriterion("OrderDays is not null");
            return (Criteria) this;
        }

        public Criteria andOrderdaysEqualTo(String value) {
            addCriterion("OrderDays =", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysNotEqualTo(String value) {
            addCriterion("OrderDays <>", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysGreaterThan(String value) {
            addCriterion("OrderDays >", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysGreaterThanOrEqualTo(String value) {
            addCriterion("OrderDays >=", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysLessThan(String value) {
            addCriterion("OrderDays <", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysLessThanOrEqualTo(String value) {
            addCriterion("OrderDays <=", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysLike(String value) {
            addCriterion("OrderDays like", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysNotLike(String value) {
            addCriterion("OrderDays not like", value, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysIn(List<String> values) {
            addCriterion("OrderDays in", values, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysNotIn(List<String> values) {
            addCriterion("OrderDays not in", values, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysBetween(String value1, String value2) {
            addCriterion("OrderDays between", value1, value2, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderdaysNotBetween(String value1, String value2) {
            addCriterion("OrderDays not between", value1, value2, "orderdays");
            return (Criteria) this;
        }

        public Criteria andOrderplanIsNull() {
            addCriterion("OrderPlan is null");
            return (Criteria) this;
        }

        public Criteria andOrderplanIsNotNull() {
            addCriterion("OrderPlan is not null");
            return (Criteria) this;
        }

        public Criteria andOrderplanEqualTo(String value) {
            addCriterion("OrderPlan =", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanNotEqualTo(String value) {
            addCriterion("OrderPlan <>", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanGreaterThan(String value) {
            addCriterion("OrderPlan >", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanGreaterThanOrEqualTo(String value) {
            addCriterion("OrderPlan >=", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanLessThan(String value) {
            addCriterion("OrderPlan <", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanLessThanOrEqualTo(String value) {
            addCriterion("OrderPlan <=", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanLike(String value) {
            addCriterion("OrderPlan like", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanNotLike(String value) {
            addCriterion("OrderPlan not like", value, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanIn(List<String> values) {
            addCriterion("OrderPlan in", values, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanNotIn(List<String> values) {
            addCriterion("OrderPlan not in", values, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanBetween(String value1, String value2) {
            addCriterion("OrderPlan between", value1, value2, "orderplan");
            return (Criteria) this;
        }

        public Criteria andOrderplanNotBetween(String value1, String value2) {
            addCriterion("OrderPlan not between", value1, value2, "orderplan");
            return (Criteria) this;
        }

        public Criteria andPublisheridIsNull() {
            addCriterion("PublisherID is null");
            return (Criteria) this;
        }

        public Criteria andPublisheridIsNotNull() {
            addCriterion("PublisherID is not null");
            return (Criteria) this;
        }

        public Criteria andPublisheridEqualTo(String value) {
            addCriterion("PublisherID =", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridNotEqualTo(String value) {
            addCriterion("PublisherID <>", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridGreaterThan(String value) {
            addCriterion("PublisherID >", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridGreaterThanOrEqualTo(String value) {
            addCriterion("PublisherID >=", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridLessThan(String value) {
            addCriterion("PublisherID <", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridLessThanOrEqualTo(String value) {
            addCriterion("PublisherID <=", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridLike(String value) {
            addCriterion("PublisherID like", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridNotLike(String value) {
            addCriterion("PublisherID not like", value, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridIn(List<String> values) {
            addCriterion("PublisherID in", values, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridNotIn(List<String> values) {
            addCriterion("PublisherID not in", values, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridBetween(String value1, String value2) {
            addCriterion("PublisherID between", value1, value2, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisheridNotBetween(String value1, String value2) {
            addCriterion("PublisherID not between", value1, value2, "publisherid");
            return (Criteria) this;
        }

        public Criteria andPublisherid0IsNull() {
            addCriterion("PublisherID0 is null");
            return (Criteria) this;
        }

        public Criteria andPublisherid0IsNotNull() {
            addCriterion("PublisherID0 is not null");
            return (Criteria) this;
        }

        public Criteria andPublisherid0EqualTo(String value) {
            addCriterion("PublisherID0 =", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0NotEqualTo(String value) {
            addCriterion("PublisherID0 <>", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0GreaterThan(String value) {
            addCriterion("PublisherID0 >", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0GreaterThanOrEqualTo(String value) {
            addCriterion("PublisherID0 >=", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0LessThan(String value) {
            addCriterion("PublisherID0 <", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0LessThanOrEqualTo(String value) {
            addCriterion("PublisherID0 <=", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0Like(String value) {
            addCriterion("PublisherID0 like", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0NotLike(String value) {
            addCriterion("PublisherID0 not like", value, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0In(List<String> values) {
            addCriterion("PublisherID0 in", values, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0NotIn(List<String> values) {
            addCriterion("PublisherID0 not in", values, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0Between(String value1, String value2) {
            addCriterion("PublisherID0 between", value1, value2, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublisherid0NotBetween(String value1, String value2) {
            addCriterion("PublisherID0 not between", value1, value2, "publisherid0");
            return (Criteria) this;
        }

        public Criteria andPublishtypeIsNull() {
            addCriterion("PublishType is null");
            return (Criteria) this;
        }

        public Criteria andPublishtypeIsNotNull() {
            addCriterion("PublishType is not null");
            return (Criteria) this;
        }

        public Criteria andPublishtypeEqualTo(String value) {
            addCriterion("PublishType =", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeNotEqualTo(String value) {
            addCriterion("PublishType <>", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeGreaterThan(String value) {
            addCriterion("PublishType >", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeGreaterThanOrEqualTo(String value) {
            addCriterion("PublishType >=", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeLessThan(String value) {
            addCriterion("PublishType <", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeLessThanOrEqualTo(String value) {
            addCriterion("PublishType <=", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeLike(String value) {
            addCriterion("PublishType like", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeNotLike(String value) {
            addCriterion("PublishType not like", value, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeIn(List<String> values) {
            addCriterion("PublishType in", values, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeNotIn(List<String> values) {
            addCriterion("PublishType not in", values, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeBetween(String value1, String value2) {
            addCriterion("PublishType between", value1, value2, "publishtype");
            return (Criteria) this;
        }

        public Criteria andPublishtypeNotBetween(String value1, String value2) {
            addCriterion("PublishType not between", value1, value2, "publishtype");
            return (Criteria) this;
        }

        public Criteria andSupplydiscIsNull() {
            addCriterion("SupplyDisc is null");
            return (Criteria) this;
        }

        public Criteria andSupplydiscIsNotNull() {
            addCriterion("SupplyDisc is not null");
            return (Criteria) this;
        }

        public Criteria andSupplydiscEqualTo(BigDecimal value) {
            addCriterion("SupplyDisc =", value, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscNotEqualTo(BigDecimal value) {
            addCriterion("SupplyDisc <>", value, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscGreaterThan(BigDecimal value) {
            addCriterion("SupplyDisc >", value, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SupplyDisc >=", value, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscLessThan(BigDecimal value) {
            addCriterion("SupplyDisc <", value, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SupplyDisc <=", value, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscIn(List<BigDecimal> values) {
            addCriterion("SupplyDisc in", values, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscNotIn(List<BigDecimal> values) {
            addCriterion("SupplyDisc not in", values, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SupplyDisc between", value1, value2, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andSupplydiscNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SupplyDisc not between", value1, value2, "supplydisc");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeIsNull() {
            addCriterion("BusinessScope is null");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeIsNotNull() {
            addCriterion("BusinessScope is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeEqualTo(String value) {
            addCriterion("BusinessScope =", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeNotEqualTo(String value) {
            addCriterion("BusinessScope <>", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeGreaterThan(String value) {
            addCriterion("BusinessScope >", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeGreaterThanOrEqualTo(String value) {
            addCriterion("BusinessScope >=", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeLessThan(String value) {
            addCriterion("BusinessScope <", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeLessThanOrEqualTo(String value) {
            addCriterion("BusinessScope <=", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeLike(String value) {
            addCriterion("BusinessScope like", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeNotLike(String value) {
            addCriterion("BusinessScope not like", value, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeIn(List<String> values) {
            addCriterion("BusinessScope in", values, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeNotIn(List<String> values) {
            addCriterion("BusinessScope not in", values, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeBetween(String value1, String value2) {
            addCriterion("BusinessScope between", value1, value2, "businessscope");
            return (Criteria) this;
        }

        public Criteria andBusinessscopeNotBetween(String value1, String value2) {
            addCriterion("BusinessScope not between", value1, value2, "businessscope");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andFactorytagIsNull() {
            addCriterion("FactoryTag is null");
            return (Criteria) this;
        }

        public Criteria andFactorytagIsNotNull() {
            addCriterion("FactoryTag is not null");
            return (Criteria) this;
        }

        public Criteria andFactorytagEqualTo(String value) {
            addCriterion("FactoryTag =", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagNotEqualTo(String value) {
            addCriterion("FactoryTag <>", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagGreaterThan(String value) {
            addCriterion("FactoryTag >", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagGreaterThanOrEqualTo(String value) {
            addCriterion("FactoryTag >=", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagLessThan(String value) {
            addCriterion("FactoryTag <", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagLessThanOrEqualTo(String value) {
            addCriterion("FactoryTag <=", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagLike(String value) {
            addCriterion("FactoryTag like", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagNotLike(String value) {
            addCriterion("FactoryTag not like", value, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagIn(List<String> values) {
            addCriterion("FactoryTag in", values, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagNotIn(List<String> values) {
            addCriterion("FactoryTag not in", values, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagBetween(String value1, String value2) {
            addCriterion("FactoryTag between", value1, value2, "factorytag");
            return (Criteria) this;
        }

        public Criteria andFactorytagNotBetween(String value1, String value2) {
            addCriterion("FactoryTag not between", value1, value2, "factorytag");
            return (Criteria) this;
        }

        public Criteria andVendordistrateIsNull() {
            addCriterion("VendorDistRate is null");
            return (Criteria) this;
        }

        public Criteria andVendordistrateIsNotNull() {
            addCriterion("VendorDistRate is not null");
            return (Criteria) this;
        }

        public Criteria andVendordistrateEqualTo(BigDecimal value) {
            addCriterion("VendorDistRate =", value, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateNotEqualTo(BigDecimal value) {
            addCriterion("VendorDistRate <>", value, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateGreaterThan(BigDecimal value) {
            addCriterion("VendorDistRate >", value, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VendorDistRate >=", value, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateLessThan(BigDecimal value) {
            addCriterion("VendorDistRate <", value, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VendorDistRate <=", value, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateIn(List<BigDecimal> values) {
            addCriterion("VendorDistRate in", values, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateNotIn(List<BigDecimal> values) {
            addCriterion("VendorDistRate not in", values, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VendorDistRate between", value1, value2, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andVendordistrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VendorDistRate not between", value1, value2, "vendordistrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateIsNull() {
            addCriterion("WastingRate is null");
            return (Criteria) this;
        }

        public Criteria andWastingrateIsNotNull() {
            addCriterion("WastingRate is not null");
            return (Criteria) this;
        }

        public Criteria andWastingrateEqualTo(BigDecimal value) {
            addCriterion("WastingRate =", value, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateNotEqualTo(BigDecimal value) {
            addCriterion("WastingRate <>", value, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateGreaterThan(BigDecimal value) {
            addCriterion("WastingRate >", value, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WastingRate >=", value, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateLessThan(BigDecimal value) {
            addCriterion("WastingRate <", value, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WastingRate <=", value, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateIn(List<BigDecimal> values) {
            addCriterion("WastingRate in", values, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateNotIn(List<BigDecimal> values) {
            addCriterion("WastingRate not in", values, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WastingRate between", value1, value2, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andWastingrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WastingRate not between", value1, value2, "wastingrate");
            return (Criteria) this;
        }

        public Criteria andOrdercycIsNull() {
            addCriterion("OrderCyc is null");
            return (Criteria) this;
        }

        public Criteria andOrdercycIsNotNull() {
            addCriterion("OrderCyc is not null");
            return (Criteria) this;
        }

        public Criteria andOrdercycEqualTo(Integer value) {
            addCriterion("OrderCyc =", value, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycNotEqualTo(Integer value) {
            addCriterion("OrderCyc <>", value, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycGreaterThan(Integer value) {
            addCriterion("OrderCyc >", value, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycGreaterThanOrEqualTo(Integer value) {
            addCriterion("OrderCyc >=", value, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycLessThan(Integer value) {
            addCriterion("OrderCyc <", value, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycLessThanOrEqualTo(Integer value) {
            addCriterion("OrderCyc <=", value, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycIn(List<Integer> values) {
            addCriterion("OrderCyc in", values, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycNotIn(List<Integer> values) {
            addCriterion("OrderCyc not in", values, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycBetween(Integer value1, Integer value2) {
            addCriterion("OrderCyc between", value1, value2, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOrdercycNotBetween(Integer value1, Integer value2) {
            addCriterion("OrderCyc not between", value1, value2, "ordercyc");
            return (Criteria) this;
        }

        public Criteria andOthernameIsNull() {
            addCriterion("OtherName is null");
            return (Criteria) this;
        }

        public Criteria andOthernameIsNotNull() {
            addCriterion("OtherName is not null");
            return (Criteria) this;
        }

        public Criteria andOthernameEqualTo(String value) {
            addCriterion("OtherName =", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameNotEqualTo(String value) {
            addCriterion("OtherName <>", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameGreaterThan(String value) {
            addCriterion("OtherName >", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameGreaterThanOrEqualTo(String value) {
            addCriterion("OtherName >=", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameLessThan(String value) {
            addCriterion("OtherName <", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameLessThanOrEqualTo(String value) {
            addCriterion("OtherName <=", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameLike(String value) {
            addCriterion("OtherName like", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameNotLike(String value) {
            addCriterion("OtherName not like", value, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameIn(List<String> values) {
            addCriterion("OtherName in", values, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameNotIn(List<String> values) {
            addCriterion("OtherName not in", values, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameBetween(String value1, String value2) {
            addCriterion("OtherName between", value1, value2, "othername");
            return (Criteria) this;
        }

        public Criteria andOthernameNotBetween(String value1, String value2) {
            addCriterion("OtherName not between", value1, value2, "othername");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}